Release 10.1A: OpenEdge Development:
Progress Dynamics Advanced Development

Enabling caching for a dynamic lookup

Dynamics supports a type of behind-the-scenes caching for dynamic lookups. The result set of the query for the SmartDataField is kept in one temp-table, and another temp-table manages the subsets of this data being used in each instance of the dynamic lookup. It improves performance by ensuring each instance does not need to store the entire database result set.

To enable caching for a dynamic lookup:

Select Build Smart Data Field Maintenance, as shown:



Enable the Use cache option.
Save and exit.